/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80100 (8.1.0)
 Source Host           : localhost:3306
 Source Schema         : admin

 Target Server Type    : MySQL
 Target Server Version : 80100 (8.1.0)
 File Encoding         : 65001

 Date: 18/05/2024 23:38:55
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for fy_article
-- ----------------------------
DROP TABLE IF EXISTS `fy_article`;
CREATE TABLE `fy_article` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章标题',
  `content` varchar(10000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文章内容',
  `type` char(1) COLLATE utf8mb4_general_ci DEFAULT '2' COMMENT '文章类型：1 文章 2 草稿',
  `summary` varchar(1024) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文章摘要',
  `category_id` bigint DEFAULT NULL COMMENT '所属分类id',
  `thumbnail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '缩略图',
  `is_top` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '是否置顶：0否 1是',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '文章状态：0已发布 1草稿',
  `comment_count` int DEFAULT '0' COMMENT '评论数',
  `view_count` bigint DEFAULT '0' COMMENT '访问量',
  `is_comment` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '是否允许评论：0否 1是',
  `create_by` bigint DEFAULT NULL COMMENT '创建人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人id',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '是否删除：0未删除 1已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of fy_article
-- ----------------------------
BEGIN;
INSERT INTO `fy_article` (`id`, `title`, `content`, `type`, `summary`, `category_id`, `thumbnail`, `is_top`, `status`, `comment_count`, `view_count`, `is_comment`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, 'Spring从入门到精通', 'Spring入门', '1', 'spring入门', 1, NULL, '0', '0', 0, 144, '1', 1, '2024-02-25 20:20:11', NULL, '2024-05-18 23:30:00', '0');
INSERT INTO `fy_article` (`id`, `title`, `content`, `type`, `summary`, `category_id`, `thumbnail`, `is_top`, `status`, `comment_count`, `view_count`, `is_comment`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, 'Java从入门到精通', 'Java入门', '1', 'Java入门', 1, NULL, '0', '0', 0, 666, '1', 1, '2024-02-25 20:20:11', NULL, '2024-05-18 23:30:00', '0');
INSERT INTO `fy_article` (`id`, `title`, `content`, `type`, `summary`, `category_id`, `thumbnail`, `is_top`, `status`, `comment_count`, `view_count`, `is_comment`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, 'PHP从入门到精通', 'PHP入门', '1', 'PHP入门', 2, NULL, '0', '0', 0, 888, '1', 1, '2024-02-25 20:20:11', NULL, '2024-05-18 23:30:00', '0');
COMMIT;

-- ----------------------------
-- Table structure for fy_category
-- ----------------------------
DROP TABLE IF EXISTS `fy_category`;
CREATE TABLE `fy_category` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(128) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分类名',
  `pid` bigint DEFAULT '-1' COMMENT '父分类id，如果没有父分类则为-1',
  `description` varchar(512) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '状态：0 正常，1禁用',
  `create_by` bigint DEFAULT NULL COMMENT '创建人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人id',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '是否删除：0未删除 1已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of fy_category
-- ----------------------------
BEGIN;
INSERT INTO `fy_category` (`id`, `name`, `pid`, `description`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, 'java', -1, 'java', '0', 1, '2024-02-25 20:20:11', 1, '2024-02-25 20:20:11', '0');
INSERT INTO `fy_category` (`id`, `name`, `pid`, `description`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, 'iOS', -1, 'iOS', '0', 1, '2024-02-25 20:20:11', 1, '2024-02-25 20:20:11', '0');
COMMIT;

-- ----------------------------
-- Table structure for fy_comment
-- ----------------------------
DROP TABLE IF EXISTS `fy_comment`;
CREATE TABLE `fy_comment` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '评论类型 0 文章评论 1 友链评论',
  `article_id` bigint DEFAULT NULL COMMENT '文章id',
  `root_id` bigint DEFAULT '-1' COMMENT '根评论id',
  `content` varchar(512) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '评论内容',
  `to_comment_user_id` bigint DEFAULT '-1' COMMENT '回复的目标评论人的userid，比如xx回复了枫叶，这里指的就是枫叶的userid',
  `to_comment_id` bigint DEFAULT '-1' COMMENT '回复的目标评论的id',
  `create_by` bigint DEFAULT NULL COMMENT '创建人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人id',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '是否删除：0未删除 1已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of fy_comment
-- ----------------------------
BEGIN;
INSERT INTO `fy_comment` (`id`, `type`, `article_id`, `root_id`, `content`, `to_comment_user_id`, `to_comment_id`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, '0', 1, -1, '你说的对', -1, -1, 1, '2024-02-29 00:20:11', 1, '2024-02-29 00:20:11', '0');
INSERT INTO `fy_comment` (`id`, `type`, `article_id`, `root_id`, `content`, `to_comment_user_id`, `to_comment_id`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (6, '0', 1, 1, '你让我说你什么好呢', 1, 1, 1, '2024-03-01 00:03:36', 1, '2024-03-01 00:03:36', '0');
INSERT INTO `fy_comment` (`id`, `type`, `article_id`, `root_id`, `content`, `to_comment_user_id`, `to_comment_id`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (7, '0', 1, 1, '111', 1, 1, 1, '2024-03-01 00:27:34', 1, '2024-03-01 00:27:34', '0');
INSERT INTO `fy_comment` (`id`, `type`, `article_id`, `root_id`, `content`, `to_comment_user_id`, `to_comment_id`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (8, '0', 1, -1, '文章写得不错', -1, -1, 1, '2024-03-01 00:28:03', 1, '2024-03-01 00:28:03', '0');
INSERT INTO `fy_comment` (`id`, `type`, `article_id`, `root_id`, `content`, `to_comment_user_id`, `to_comment_id`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (11, '0', 1, 8, '谢谢', 1, 8, 1, '2024-03-01 00:28:03', 1, '2024-03-01 00:28:03', '0');
INSERT INTO `fy_comment` (`id`, `type`, `article_id`, `root_id`, `content`, `to_comment_user_id`, `to_comment_id`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (12, '0', 1, 8, 'xiexie', 1, 8, 1, '2024-03-01 00:54:59', 1, '2024-03-01 00:54:59', '0');
INSERT INTO `fy_comment` (`id`, `type`, `article_id`, `root_id`, `content`, `to_comment_user_id`, `to_comment_id`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (13, '0', 1, 1, '1123', 1, 7, 1, '2024-03-01 00:58:07', 1, '2024-03-01 00:58:07', '0');
COMMIT;

-- ----------------------------
-- Table structure for fy_pictures
-- ----------------------------
DROP TABLE IF EXISTS `fy_pictures`;
CREATE TABLE `fy_pictures` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '图片模板的唯一ID',
  `category_id` bigint NOT NULL COMMENT '图片模板分类id',
  `title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL COMMENT '图片模板的标题',
  `width` int NOT NULL COMMENT '图片模板的宽度（像素）',
  `height` int NOT NULL COMMENT '图片模板高度（像素）',
  `likes` int NOT NULL DEFAULT '0' COMMENT '图片模板被喜欢的次数',
  `views` int NOT NULL DEFAULT '0' COMMENT '图片模板被浏览的次数',
  `url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '帖子内容的URL',
  `create_by` bigint NOT NULL COMMENT '创建人id',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_by` bigint NOT NULL COMMENT '更新人id',
  `update_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='存储图片模板的表';

-- ----------------------------
-- Records of fy_pictures
-- ----------------------------
BEGIN;
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 0, 'あ、先輩、お、おはようございます。', 1280, 1920, 167, 2263, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/08/07/08/00/07/110604224_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2, 0, 'あ、お兄さん、こんなところに何の用事ですか？', 1024, 1536, 148, 1862, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/08/29/20/00/07/111268081_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (3, 0, '\"分かりました、恥ずかしいけど脱ぎましょう。', 1280, 1920, 138, 1269, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/09/02/03/00/00/111366856_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (4, 0, '『冗談だよ、ほら夢から覚めて』', 1200, 1536, 137, 1312, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/08/22/21/11/34/111069976_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (5, 0, '私たちの夢の舞台へ、ようこそ！', 1024, 1536, 72, 1661, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/06/16/12/00/06/109054882_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (6, 0, 'わ！ご主人様が自力で起きてる！？', 1280, 1920, 105, 1736, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/07/05/09/00/02/109634440_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (7, 0, 'お願い、もう…許してよ…', 1024, 1536, 84, 1725, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/05/25/03/00/01/108416780_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (8, 0, '『ご主人様、お呼びでしょうか』', 1144, 1536, 219, 2011, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/04/10/15/28/22/107048939_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (9, 0, '史爾特爾泳裝 surtur', 1792, 1280, 23, 3211, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/03/15/00/14/29/106222473_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (10, 0, 'ムムム、何かが起こりそうな気配…。', 1280, 1920, 52, 1323, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/07/06/21/00/02/109676595_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (11, 0, 'ｻｻｻ', 1800, 2520, 52, 5323, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/10/24/00/00/29/112799011_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (12, 0, '「あら？貴方も常連ですか？よく会いますね」', 1080, 1440, 23, 3241, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/10/04/23/53/59/112277049_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (13, 0, '『あの、すみませんご主人様…』', 1163, 1488, 52, 1312, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/09/29/22/41/40/112132745_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (14, 0, '「これ運ぶの手伝ってもらえる？お礼するから」', 1080, 1440, 56, 334, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/09/22/18/33/55/111935870_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (15, 0, '次は何食べよっか？', 1280, 1920, 146, 1920, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/07/18/14/00/01/110023877_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (16, 0, 'さすがにちょっと大胆すぎたかしら？', 1280, 1920, 121, 3223, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/09/26/20/00/00/112053326_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (17, 0, '今日はキミを独り占めしていいのね？', 1280, 1920, 83, 909, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/11/01/12/00/05/113041209_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (18, 0, '「ここ、近道だから。２人だけの秘密ね」', 1080, 1440, 58, 278, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/09/27/20/34/41/112079306_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (19, 0, 'おはようございます。', 1024, 1536, 215, 1813, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/06/15/06/00/02/109023978_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (20, 0, 'カメラはどっち？ こっちね、ピースっ！', 1280, 1920, 72, 705, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/10/08/13/00/01/112370817_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (21, 0, '私はもう心の準備は出来てるよ。', 1024, 1536, 108, 1354, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/10/06/14/00/01/112315126_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (22, 0, '『実は、最近私に結婚を迫る方が多いのです…』', 1200, 1536, 120, 1109, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/05/21/15/52/22/108315469_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (23, 0, '雷電将軍', 2506, 3840, 606, 3362, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/08/02/00/00/25/110445196_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (24, 0, '私はオオカミさんに食べられちゃうんですかっ？', 512, 768, 111, 1397, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/08/29/21/00/04/111269720_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
INSERT INTO `fy_pictures` (`id`, `category_id`, `title`, `width`, `height`, `likes`, `views`, `url`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (25, 0, 'フラワーキャット', 4096, 4096, 25, 348, 'https://i.pixiv.re/c/540x540_70/img-master/img/2023/05/21/21/27/14/108325433_p0_master1200.jpg', 1, '2024-05-18 22:19:51', 1, '2024-05-18 22:19:51');
COMMIT;

-- ----------------------------
-- Table structure for fy_user
-- ----------------------------
DROP TABLE IF EXISTS `fy_user`;
CREATE TABLE `fy_user` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户名',
  `nickname` varchar(64) COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵称',
  `password` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
  `email` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '电子邮箱',
  `phone` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '电话号码',
  `type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '用户类型：0 普通用户 1管理员用户',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '账户状态：0 正常 1停用',
  `sex` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '性别：0-女，1-男，2-未知',
  `avatar` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '头像',
  `create_by` bigint DEFAULT NULL COMMENT '创建人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人id',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '是否删除：0未删除 1已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of fy_user
-- ----------------------------
BEGIN;
INSERT INTO `fy_user` (`id`, `username`, `nickname`, `password`, `email`, `phone`, `type`, `status`, `sex`, `avatar`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, 'fengye', '枫叶', '$2a$10$QVTXBB8p//TzuZUQTR3fN.5memK8D9gRq8bOnL3hofuHtTxdwTisC', 'fengye@gg.com', '15201051230', '0', '0', '1', 'https://www.baidu.com/avaasdf.jpg', -1, '2024-02-25 02:42:07', -1, '2024-02-25 02:42:07', '0');
INSERT INTO `fy_user` (`id`, `username`, `nickname`, `password`, `email`, `phone`, `type`, `status`, `sex`, `avatar`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, 'fengye1', '枫叶1', '$2a$10$UhqZzgULxaBOiz0.YuQhcuFYs0akFXvInfeFNd7S3btpuNcmzWhiG', 'fengye1@qq.com', '15201051237', '0', '0', '1', 'https://www.baidu.com', -1, '2024-02-29 23:15:30', -1, '2024-02-29 23:15:30', '0');
INSERT INTO `fy_user` (`id`, `username`, `nickname`, `password`, `email`, `phone`, `type`, `status`, `sex`, `avatar`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, 'fengye2', '枫叶2', '$2a$10$X7h8Ud1UXVkc1V7rlJThCeyUOS.oHoxA0OC0gvQqSZhNkhj7MnR5G', 'fengye1@qq.com', '15201051237', '0', '0', '1', 'https://www.baidu.com', -1, '2024-02-29 23:17:58', -1, '2024-02-29 23:17:58', '0');
INSERT INTO `fy_user` (`id`, `username`, `nickname`, `password`, `email`, `phone`, `type`, `status`, `sex`, `avatar`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4, 'fengye3', '枫叶3', '$2a$10$YD7/xwFkXVObp4uuS90HuuxTGnox.N1mUGOx1EJcWWwXrT9EFzmHy', 'fengye1@qq.com', '15201051237', '0', '0', '1', 'https://www.baidu.com', -1, '2024-02-29 23:18:05', -1, '2024-02-29 23:18:05', '0');
INSERT INTO `fy_user` (`id`, `username`, `nickname`, `password`, `email`, `phone`, `type`, `status`, `sex`, `avatar`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5, 'fengye4', '枫叶4', '$2a$10$3t5d3ngJy6fnhTKpcuxJceyeUX2i2v5FCJlO8vNjrGPga/KHqNXtO', 'fengye1@qq.com', '15201051237', '0', '0', '0', 'https://www.baidu.com', -1, '2024-02-29 23:18:17', -1, '2024-02-29 23:18:17', '0');
INSERT INTO `fy_user` (`id`, `username`, `nickname`, `password`, `email`, `phone`, `type`, `status`, `sex`, `avatar`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (6, 'fengye5', '枫叶5', '$2a$10$CC1JTRvnGukBjcMWaE0pI.gV39SohsJFGGxp.IzjBojSgGa0uvbBS', 'fengye1@qq.com', '15201051237', '0', '0', '0', 'https://www.baidu.com', -1, '2024-02-29 23:18:25', -1, '2024-02-29 23:18:25', '0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
